package cemp.mapper;

import cemp.entity.StockAvg;
import cemp.entity.StockKpiDay;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author xsb_t
* @description 针对表【stock_avg】的数据库操作Mapper
* @createDate 2025-03-19 21:01:07
* @Entity cemp.entity.StockAvg
*/
public interface StockAvgMapper extends BaseMapper<StockAvg> {


    @Select("select * from stock_avg t1 where t1.sta_date < #{endDate} and t1.sta_date > #{startDate} ")
    List<StockAvg> getLatest(@Param("endDate")String endDate, @Param("startDate")String startDate);
}




